CREATE TABLE [dbo].[AsiNrdsMemberEducation]
(
[ID] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AsiNrdsMemberEducation_ID] DEFAULT (''),
[SEQN] [int] NOT NULL CONSTRAINT [DF_AsiNrdsMemberEducation_SEQN] DEFAULT ((0)),
[AssociationId] [varchar] (4) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AsiNrdsMemberEducation_AssociationId] DEFAULT (''),
[CertificateName] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AsiNrdsMemberEducation_CertificateName] DEFAULT (''),
[Comments] [varchar] (80) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AsiNrdsMemberEducation_Comments] DEFAULT (''),
[CourseCode] [varchar] (7) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AsiNrdsMemberEducation_CourseCode] DEFAULT (''),
[CourseCompletionDate] [datetime] NULL,
[CourseDescription] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AsiNrdsMemberEducation_CourseDescription] DEFAULT (''),
[CourseNumber] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AsiNrdsMemberEducation_CourseNumber] DEFAULT (''),
[CourseStartDate] [datetime] NULL,
[DateSentToLocalAssociation] [datetime] NULL,
[DateSentToNarIsc] [datetime] NULL,
[DateSentToStateAgency] [datetime] NULL,
[DateSentToStateAssociation] [datetime] NULL,
[DeliveryMethod] [varchar] (6) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AsiNrdsMemberEducation_DeliveryMethod] DEFAULT (''),
[DesignationCreditHours] [varchar] (5) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AsiNrdsMemberEducation_DesignationCreditHours] DEFAULT (''),
[GroupCode] [varchar] (7) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AsiNrdsMemberEducation_GroupCode] DEFAULT (''),
[HostingAssociationId] [varchar] (4) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AsiNrdsMemberEducation_HostingAssociationId] DEFAULT (''),
[Instructor1Name] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AsiNrdsMemberEducation_Instructor1Name] DEFAULT (''),
[Instructor1StateLicenseNumber] [varchar] (11) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AsiNrdsMemberEducation_Instructor1StateLicenseNumber] DEFAULT (''),
[Instructor2Name] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AsiNrdsMemberEducation_Instructor2Name] DEFAULT (''),
[Instructor2StateLicenseNumber] [varchar] (11) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AsiNrdsMemberEducation_Instructor2StateLicenseNumber] DEFAULT (''),
[MemberId] [varchar] (9) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AsiNrdsMemberEducation_MemberId] DEFAULT (''),
[PaymentAmount] [varchar] (7) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AsiNrdsMemberEducation_PaymentAmount] DEFAULT (''),
[PaymentCode] [varchar] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AsiNrdsMemberEducation_PaymentCode] DEFAULT (''),
[PointOfEntry] [varchar] (9) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AsiNrdsMemberEducation_PointOfEntry] DEFAULT (''),
[SponsoringAssociationId] [varchar] (4) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AsiNrdsMemberEducation_SponsoringAssociationId] DEFAULT (''),
[StateAgencyCourseCode] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AsiNrdsMemberEducation_StateAgencyCourseCode] DEFAULT (''),
[StateCEHours] [varchar] (5) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AsiNrdsMemberEducation_StateCEHours] DEFAULT (''),
[TestMailingAddress] [varchar] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AsiNrdsMemberEducation_TestMailingAddress] DEFAULT (''),
[TestScore] [varchar] (5) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AsiNrdsMemberEducation_TestScore] DEFAULT (''),
[TestScoreDateOfChange] [datetime] NULL,
[TestScoreOperator] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AsiNrdsMemberEducation_TestScoreOperator] DEFAULT (''),
[TestStatus] [varchar] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AsiNrdsMemberEducation_TestStatus] DEFAULT (''),
[TotalHoursEarnedToDate] [varchar] (5) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AsiNrdsMemberEducation_TotalHoursEarnedToDate] DEFAULT (''),
[NARTimestamp] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_AsiNrdsMemberEducation_NARTimestamp] DEFAULT (''),
[TIME_STAMP] [timestamp] NULL
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[AsiNrdsMemberEducation] ADD CONSTRAINT [PK_AsiNrdsMemberEducation] PRIMARY KEY CLUSTERED ([ID], [SEQN]) ON [PRIMARY]
GO